HELOC Data Profiling Report- v2

Dataset statistics

Number of variables	18
Number of observations	9682
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	2
Duplicate rows (%)	< 0.1%
Total size in memory	1.7 MiB
Average record size in memory	188.5 B

Variable types

Categorical	1
Numeric	17

Alerts

Dataset has 2 (< 0.1%) duplicate rows	Duplicates
`ExternalRiskEstimate` is highly overall correlated with `MaxDelq/PublicRecLast12M` and 3 other fields	High correlation
`MSinceMostRecentTradeOpen` is highly overall correlated with `NumTradesOpeninLast12M`	High correlation
`MaxDelq/PublicRecLast12M` is highly overall correlated with `ExternalRiskEstimate` and 3 other fields	High correlation
`MaxDelqEver` is highly overall correlated with `ExternalRiskEstimate` and 4 other fields	High correlation
`NetFractionRevolvingBurden` is highly overall correlated with `ExternalRiskEstimate` and 1 other fields	High correlation
`NumInqLast6M` is highly overall correlated with `NumInqLast6Mexcl7days`	High correlation
`NumInqLast6Mexcl7days` is highly overall correlated with `NumInqLast6M`	High correlation
`NumSatisfactoryTrades` is highly overall correlated with `NumTotalTrades`	High correlation
`NumTotalTrades` is highly overall correlated with `NumSatisfactoryTrades`	High correlation
`NumTrades60Ever/DerogPubRec` is highly overall correlated with `MaxDelq/PublicRecLast12M` and 3 other fields	High correlation
`NumTrades90Ever/DerogPubRec` is highly overall correlated with `MaxDelqEver` and 1 other fields	High correlation
`NumTradesOpeninLast12M` is highly overall correlated with `MSinceMostRecentTradeOpen`	High correlation
`PercentTradesNeverDelq` is highly overall correlated with `ExternalRiskEstimate` and 3 other fields	High correlation
`PercentTradesWBalance` is highly overall correlated with `NetFractionRevolvingBurden`	High correlation
`MSinceMostRecentTradeOpen` has 105 (1.1%) zeros	Zeros
`NumTrades60Ever/DerogPubRec` has 6706 (69.3%) zeros	Zeros
`NumTrades90Ever/DerogPubRec` has 7528 (77.8%) zeros	Zeros
`MaxDelq/PublicRecLast12M` has 323 (3.3%) zeros	Zeros
`NumTotalTrades` has 131 (1.4%) zeros	Zeros
`NumTradesOpeninLast12M` has 2397 (24.8%) zeros	Zeros
`PercentInstallTrades` has 186 (1.9%) zeros	Zeros
`NumInqLast6M` has 3838 (39.6%) zeros	Zeros
`NumInqLast6Mexcl7days` has 3986 (41.2%) zeros	Zeros
`NetFractionRevolvingBurden` has 608 (6.3%) zeros	Zeros
`NumRevolvingTradesWBalance` has 295 (3.0%) zeros	Zeros

Reproduction

Analysis started	2024-05-31 09:30:38.251235
Analysis finished	2024-05-31 09:32:05.852619
Duration	1 minute and 27.6 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

RiskPerformance
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	496.4 KiB

Bad	4985
Good	4697

Length

Max length	4
Median length	3
Mean length	3.485127
Min length	3

Characters and Unicode

Total characters	33743
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Bad
2nd row	Bad
3rd row	Bad
4th row	Bad
5th row	Bad

Common Values

Value	Count	Frequency (%)
Bad	4985	51.5%
Good	4697	48.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
bad	4985	51.5%
good	4697	48.5%

Most occurring characters

Value	Count	Frequency (%)
d	9682	28.7%
o	9394	27.8%
B	4985	14.8%
a	4985	14.8%
G	4697	13.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	33743	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
d	9682	28.7%
o	9394	27.8%
B	4985	14.8%
a	4985	14.8%
G	4697	13.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	33743	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
d	9682	28.7%
o	9394	27.8%
B	4985	14.8%
a	4985	14.8%
G	4697	13.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	33743	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
d	9682	28.7%
o	9394	27.8%
B	4985	14.8%
a	4985	14.8%
G	4697	13.9%

ExternalRiskEstimate
Real number (ℝ)

HIGH CORRELATION

Distinct	59
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	72.150072

Minimum	33
Maximum	94
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	75.8 KiB

Quantile statistics

Minimum	33
5-th percentile	57
Q1	65
median	72
Q3	80
95-th percentile	88
Maximum	94
Range	61
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	9.8768418
Coefficient of variation (CV)	0.13689303
Kurtosis	-0.77192456
Mean	72.150072
Median Absolute Deviation (MAD)	8
Skewness	-0.0057167372
Sum	698557
Variance	97.552003
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
65	378	3.9%
66	365	3.8%
72	362	3.7%
68	362	3.7%
73	359	3.7%
70	344	3.6%
63	331	3.4%
75	328	3.4%
69	306	3.2%
80	297	3.1%
Other values (49)	6250	64.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
33	1	< 0.1%
34	1	< 0.1%
36	2	< 0.1%
37	1	< 0.1%
40	2	< 0.1%
41	1	< 0.1%
42	2	< 0.1%
43	4	< 0.1%
44	4	< 0.1%
45	3	< 0.1%

Value	Count	Frequency (%)
94	1	< 0.1%
93	16	0.2%
92	34	0.4%
91	103	1.1%
90	100	1.0%
89	160	1.7%
88	200	2.1%
87	190	2.0%
86	253	2.6%
85	223	2.3%

MSinceMostRecentTradeOpen
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	104
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.287957

Minimum	0
Maximum	227
Zeros	105
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	75.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	3
median	6
Q3	11
95-th percentile	28
Maximum	227
Range	227
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	11.727606
Coefficient of variation (CV)	1.262668
Kurtosis	52.992534
Mean	9.287957
Median Absolute Deviation (MAD)	4
Skewness	5.2940624
Sum	89926
Variance	137.53674
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	1152	11.9%
3	1004	10.4%
4	876	9.0%
5	747	7.7%
1	731	7.6%
6	652	6.7%
7	569	5.9%
8	458	4.7%
9	405	4.2%
10	304	3.1%
Other values (94)	2784	28.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	105	1.1%
1	731	7.6%
2	1152	11.9%
3	1004	10.4%
4	876	9.0%
5	747	7.7%
6	652	6.7%
7	569	5.9%
8	458	4.7%
9	405	4.2%

Value	Count	Frequency (%)
227	1	< 0.1%
207	1	< 0.1%
184	1	< 0.1%
178	1	< 0.1%
163	1	< 0.1%
156	1	< 0.1%
152	1	< 0.1%
143	2	< 0.1%
121	1	< 0.1%
119	1	< 0.1%

AverageMInFile
Real number (ℝ)

Distinct	235
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	79.109275

Minimum	4
Maximum	322
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	75.8 KiB

Quantile statistics

Minimum	4
5-th percentile	29
Q1	58
median	76
Q3	97
95-th percentile	139
Maximum	322
Range	318
Interquartile range (IQR)	39

Descriptive statistics

Standard deviation	33.712984
Coefficient of variation (CV)	0.42615716
Kurtosis	2.194652
Mean	79.109275
Median Absolute Deviation (MAD)	19
Skewness	0.88188721
Sum	765936
Variance	1136.5653
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
79	154	1.6%
71	153	1.6%
74	146	1.5%
80	145	1.5%
68	145	1.5%
75	144	1.5%
84	143	1.5%
69	139	1.4%
81	138	1.4%
70	138	1.4%
Other values (225)	8237	85.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4	3	< 0.1%
5	6	0.1%
6	4	< 0.1%
7	7	0.1%
8	10	0.1%
9	13	0.1%
10	11	0.1%
11	8	0.1%
12	10	0.1%
13	16	0.2%

Value	Count	Frequency (%)
322	1	< 0.1%
275	1	< 0.1%
273	1	< 0.1%
263	1	< 0.1%
258	1	< 0.1%
257	1	< 0.1%
256	1	< 0.1%
252	1	< 0.1%
249	1	< 0.1%
245	1	< 0.1%

NumSatisfactoryTrades
Real number (ℝ)

HIGH CORRELATION

Distinct	73
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.426048

Minimum	0
Maximum	79
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	75.8 KiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	13
median	20
Q3	28
95-th percentile	42
Maximum	79
Range	79
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	11.178171
Coefficient of variation (CV)	0.52170941
Kurtosis	0.87911936
Mean	21.426048
Median Absolute Deviation (MAD)	7
Skewness	0.82504621
Sum	207447
Variance	124.95151
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18	384	4.0%
15	384	4.0%
16	376	3.9%
22	367	3.8%
19	365	3.8%
13	360	3.7%
21	346	3.6%
14	345	3.6%
20	342	3.5%
17	335	3.5%
Other values (63)	6078	62.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	20	0.2%
2	56	0.6%
3	73	0.8%
4	124	1.3%
5	143	1.5%
6	180	1.9%
7	201	2.1%
8	210	2.2%
9	249	2.6%

Value	Count	Frequency (%)
79	1	< 0.1%
78	1	< 0.1%
75	1	< 0.1%
74	1	< 0.1%
70	2	< 0.1%
67	3	< 0.1%
66	2	< 0.1%
65	4	< 0.1%
64	6	0.1%
63	5	0.1%

NumTrades60Ever/DerogPubRec
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	18
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5743648

Minimum	0
Maximum	19
Zeros	6706
Zeros (%)	69.3%
Negative	0
Negative (%)	0.0%
Memory size	75.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	19
Range	19
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.236724
Coefficient of variation (CV)	2.153203
Kurtosis	29.315425
Mean	0.5743648
Median Absolute Deviation (MAD)	0
Skewness	4.2301312
Sum	5561
Variance	1.5294863
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0	6706	69.3%
1	1758	18.2%
2	661	6.8%
3	237	2.4%
4	145	1.5%
5	69	0.7%
6	36	0.4%
7	29	0.3%
8	11	0.1%
10	8	0.1%
Other values (8)	22	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6706	69.3%
1	1758	18.2%
2	661	6.8%
3	237	2.4%
4	145	1.5%
5	69	0.7%
6	36	0.4%
7	29	0.3%
8	11	0.1%
9	8	0.1%

Value	Count	Frequency (%)
19	1	< 0.1%
17	1	< 0.1%
16	1	< 0.1%
14	2	< 0.1%
13	2	< 0.1%
12	3	< 0.1%
11	4	< 0.1%
10	8	0.1%
9	8	0.1%
8	11	0.1%

NumTrades90Ever/DerogPubRec
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	16
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.37688494

Minimum	0
Maximum	19
Zeros	7528
Zeros (%)	77.8%
Negative	0
Negative (%)	0.0%
Memory size	75.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	19
Range	19
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.98651934
Coefficient of variation (CV)	2.6175611
Kurtosis	53.650237
Mean	0.37688494
Median Absolute Deviation (MAD)	0
Skewness	5.5890429
Sum	3649
Variance	0.97322042
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0	7528	77.8%
1	1398	14.4%
2	463	4.8%
3	123	1.3%
4	80	0.8%
5	33	0.3%
6	17	0.2%
7	16	0.2%
9	8	0.1%
10	5	0.1%
Other values (6)	11	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7528	77.8%
1	1398	14.4%
2	463	4.8%
3	123	1.3%
4	80	0.8%
5	33	0.3%
6	17	0.2%
7	16	0.2%
8	3	< 0.1%
9	8	0.1%

Value	Count	Frequency (%)
19	1	< 0.1%
16	2	< 0.1%
14	1	< 0.1%
12	2	< 0.1%
11	2	< 0.1%
10	5	0.1%
9	8	0.1%
8	3	< 0.1%
7	16	0.2%
6	17	0.2%

PercentTradesNeverDelq
Real number (ℝ)

HIGH CORRELATION

Distinct	71
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	92.545342

Minimum	0
Maximum	100
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	75.8 KiB

Quantile statistics

Minimum	0
5-th percentile	69
Q1	89
median	97
Q3	100
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	11.327507
Coefficient of variation (CV)	0.12239954
Kurtosis	6.6924901
Mean	92.545342
Median Absolute Deviation (MAD)	3
Skewness	-2.3042416
Sum	896024
Variance	128.31243
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	4511	46.6%
96	414	4.3%
97	389	4.0%
95	377	3.9%
94	351	3.6%
93	304	3.1%
92	292	3.0%
88	240	2.5%
90	216	2.2%
89	200	2.1%
Other values (61)	2388	24.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
11	1	< 0.1%
20	3	< 0.1%
22	1	< 0.1%
25	4	< 0.1%
27	1	< 0.1%
28	1	< 0.1%
29	4	< 0.1%
30	4	< 0.1%
31	3	< 0.1%

Value	Count	Frequency (%)
100	4511	46.6%
99	5	0.1%
98	173	1.8%
97	389	4.0%
96	414	4.3%
95	377	3.9%
94	351	3.6%
93	304	3.1%
92	292	3.0%
91	186	1.9%

MaxDelq/PublicRecLast12M
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	9
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7580045

Minimum	0
Maximum	9
Zeros	323
Zeros (%)	3.3%
Negative	0
Negative (%)	0.0%
Memory size	75.8 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	5
median	6
Q3	7
95-th percentile	7
Maximum	9
Range	9
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.6379198
Coefficient of variation (CV)	0.28445962
Kurtosis	3.1790593
Mean	5.7580045
Median Absolute Deviation (MAD)	1
Skewness	-1.7727301
Sum	55749
Variance	2.6827812
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
7	4147	42.8%
6	3056	31.6%
4	1596	16.5%
0	323	3.3%
5	232	2.4%
3	222	2.3%
1	52	0.5%
2	52	0.5%
9	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	323	3.3%
1	52	0.5%
2	52	0.5%
3	222	2.3%
4	1596	16.5%
5	232	2.4%
6	3056	31.6%
7	4147	42.8%
9	2	< 0.1%

Value	Count	Frequency (%)
9	2	< 0.1%
7	4147	42.8%
6	3056	31.6%
5	232	2.4%
4	1596	16.5%
3	222	2.3%
2	52	0.5%
1	52	0.5%
0	323	3.3%

MaxDelqEver
Real number (ℝ)

HIGH CORRELATION

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.3795703

Minimum	2
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	75.8 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	6
median	6
Q3	8
95-th percentile	8
Maximum	8
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.8403953
Coefficient of variation (CV)	0.28848265
Kurtosis	0.11145921
Mean	6.3795703
Median Absolute Deviation (MAD)	2
Skewness	-0.98469612
Sum	61767
Variance	3.387055
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
8	4437	45.8%
6	2840	29.3%
5	950	9.8%
2	712	7.4%
4	312	3.2%
3	302	3.1%
7	129	1.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	712	7.4%
3	302	3.1%
4	312	3.2%
5	950	9.8%
6	2840	29.3%
7	129	1.3%
8	4437	45.8%

Value	Count	Frequency (%)
8	4437	45.8%
7	129	1.3%
6	2840	29.3%
5	950	9.8%
4	312	3.2%
3	302	3.1%
2	712	7.4%

NumTotalTrades
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	87
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.932452

Minimum	0
Maximum	104
Zeros	131
Zeros (%)	1.4%
Negative	0
Negative (%)	0.0%
Memory size	75.8 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	14
median	21
Q3	30
95-th percentile	46
Maximum	104
Range	104
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	12.892225
Coefficient of variation (CV)	0.56218258
Kurtosis	1.5274942
Mean	22.932452
Median Absolute Deviation (MAD)	8
Skewness	0.94262895
Sum	222032
Variance	166.20946
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15	355	3.7%
16	354	3.7%
17	345	3.6%
22	333	3.4%
20	327	3.4%
24	325	3.4%
21	320	3.3%
18	312	3.2%
23	311	3.2%
19	310	3.2%
Other values (77)	6390	66.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	131	1.4%
1	26	0.3%
2	51	0.5%
3	92	1.0%
4	105	1.1%
5	116	1.2%
6	137	1.4%
7	176	1.8%
8	176	1.8%
9	231	2.4%

Value	Count	Frequency (%)
104	1	< 0.1%
100	1	< 0.1%
87	1	< 0.1%
86	1	< 0.1%
85	1	< 0.1%
84	1	< 0.1%
83	3	< 0.1%
82	2	< 0.1%
79	2	< 0.1%
78	2	< 0.1%

NumTradesOpeninLast12M
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	18
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.8878331

Minimum	0
Maximum	19
Zeros	2397
Zeros (%)	24.8%
Negative	0
Negative (%)	0.0%
Memory size	75.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	3
95-th percentile	5
Maximum	19
Range	19
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.8320164
Coefficient of variation (CV)	0.97043347
Kurtosis	4.2279293
Mean	1.8878331
Median Absolute Deviation (MAD)	1
Skewness	1.5302521
Sum	18278
Variance	3.3562841
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
1	2477	25.6%
0	2397	24.8%
2	1950	20.1%
3	1296	13.4%
4	743	7.7%
5	365	3.8%
6	229	2.4%
7	108	1.1%
8	56	0.6%
9	24	0.2%
Other values (8)	37	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2397	24.8%
1	2477	25.6%
2	1950	20.1%
3	1296	13.4%
4	743	7.7%
5	365	3.8%
6	229	2.4%
7	108	1.1%
8	56	0.6%
9	24	0.2%

Value	Count	Frequency (%)
19	1	< 0.1%
17	1	< 0.1%
16	1	< 0.1%
14	2	< 0.1%
13	2	< 0.1%
12	4	< 0.1%
11	8	0.1%
10	18	0.2%
9	24	0.2%
8	56	0.6%

PercentInstallTrades
Real number (ℝ)

ZEROS

Distinct	94
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.853646

Minimum	0
Maximum	94
Zeros	186
Zeros (%)	1.9%
Negative	0
Negative (%)	0.0%
Memory size	75.8 KiB

Quantile statistics

Minimum	0
5-th percentile	9
Q1	21
median	33
Q3	45
95-th percentile	64
Maximum	94
Range	94
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	16.827315
Coefficient of variation (CV)	0.49706063
Kurtosis	-0.0612557
Mean	33.853646
Median Absolute Deviation (MAD)	12
Skewness	0.43904903
Sum	327771
Variance	283.15852
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33	446	4.6%
50	401	4.1%
29	332	3.4%
25	320	3.3%
38	274	2.8%
20	271	2.8%
36	247	2.6%
40	239	2.5%
27	226	2.3%
17	224	2.3%
Other values (84)	6702	69.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	186	1.9%
2	1	< 0.1%
3	12	0.1%
4	29	0.3%
5	31	0.3%
6	36	0.4%
7	57	0.6%
8	77	0.8%
9	83	0.9%
10	84	0.9%

Value	Count	Frequency (%)
94	1	< 0.1%
93	1	< 0.1%
92	2	< 0.1%
91	2	< 0.1%
90	3	< 0.1%
89	4	< 0.1%
88	3	< 0.1%
87	3	< 0.1%
86	9	0.1%
85	6	0.1%

NumInqLast6M
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	26
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.4570337

Minimum	0
Maximum	66
Zeros	3838
Zeros (%)	39.6%
Negative	0
Negative (%)	0.0%
Memory size	75.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	5
Maximum	66
Range	66
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.1329779
Coefficient of variation (CV)	1.463918
Kurtosis	118.69404
Mean	1.4570337
Median Absolute Deviation (MAD)	1
Skewness	6.221707
Sum	14107
Variance	4.5495947
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
0	3838	39.6%
1	2498	25.8%
2	1487	15.4%
3	751	7.8%
4	480	5.0%
5	239	2.5%
6	134	1.4%
7	81	0.8%
8	61	0.6%
9	32	0.3%
Other values (16)	81	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3838	39.6%
1	2498	25.8%
2	1487	15.4%
3	751	7.8%
4	480	5.0%
5	239	2.5%
6	134	1.4%
7	81	0.8%
8	61	0.6%
9	32	0.3%

Value	Count	Frequency (%)
66	1	< 0.1%
46	1	< 0.1%
29	1	< 0.1%
24	2	< 0.1%
21	1	< 0.1%
20	1	< 0.1%
19	3	< 0.1%
18	1	< 0.1%
17	2	< 0.1%
16	4	< 0.1%

NumInqLast6Mexcl7days
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	25
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3985747

Minimum	0
Maximum	66
Zeros	3986
Zeros (%)	41.2%
Negative	0
Negative (%)	0.0%
Memory size	75.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	5
Maximum	66
Range	66
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.0928973
Coefficient of variation (CV)	1.4964501
Kurtosis	128.06333
Mean	1.3985747
Median Absolute Deviation (MAD)	1
Skewness	6.4871004
Sum	13541
Variance	4.380219
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
0	3986	41.2%
1	2483	25.6%
2	1431	14.8%
3	750	7.7%
4	444	4.6%
5	228	2.4%
6	127	1.3%
7	71	0.7%
8	59	0.6%
9	26	0.3%
Other values (15)	77	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3986	41.2%
1	2483	25.6%
2	1431	14.8%
3	750	7.7%
4	444	4.6%
5	228	2.4%
6	127	1.3%
7	71	0.7%
8	59	0.6%
9	26	0.3%

Value	Count	Frequency (%)
66	1	< 0.1%
46	1	< 0.1%
29	1	< 0.1%
24	2	< 0.1%
21	1	< 0.1%
20	1	< 0.1%
19	2	< 0.1%
18	2	< 0.1%
16	4	< 0.1%
15	2	< 0.1%

NetFractionRevolvingBurden
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	126
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.862219

Minimum	0
Maximum	232
Zeros	608
Zeros (%)	6.3%
Negative	0
Negative (%)	0.0%
Memory size	75.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	9
median	29
Q3	56
95-th percentile	89
Maximum	232
Range	232
Interquartile range (IQR)	47

Descriptive statistics

Standard deviation	28.899643
Coefficient of variation (CV)	0.82896741
Kurtosis	-0.4760277
Mean	34.862219
Median Absolute Deviation (MAD)	23
Skewness	0.62400043
Sum	337536
Variance	835.18936
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	608	6.3%
1	303	3.1%
2	274	2.8%
3	259	2.7%
4	225	2.3%
5	208	2.1%
6	198	2.0%
8	166	1.7%
9	151	1.6%
7	150	1.5%
Other values (116)	7140	73.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	608	6.3%
1	303	3.1%
2	274	2.8%
3	259	2.7%
4	225	2.3%
5	208	2.1%
6	198	2.0%
7	150	1.5%
8	166	1.7%
9	151	1.6%

Value	Count	Frequency (%)
232	1	< 0.1%
165	1	< 0.1%
154	1	< 0.1%
135	1	< 0.1%
131	1	< 0.1%
126	1	< 0.1%
124	1	< 0.1%
120	2	< 0.1%
118	2	< 0.1%
117	1	< 0.1%

NumRevolvingTradesWBalance
Real number (ℝ)

ZEROS

Distinct	29
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.1124768

Minimum	0
Maximum	32
Zeros	295
Zeros (%)	3.0%
Negative	0
Negative (%)	0.0%
Memory size	75.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	10
Maximum	32
Range	32
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	3.0203407
Coefficient of variation (CV)	0.73443349
Kurtosis	5.2551092
Mean	4.1124768
Median Absolute Deviation (MAD)	2
Skewness	1.6947093
Sum	39817
Variance	9.1224577
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
2	1708	17.6%
3	1608	16.6%
4	1361	14.1%
1	1309	13.5%
5	1010	10.4%
6	743	7.7%
7	506	5.2%
8	350	3.6%
0	295	3.0%
9	242	2.5%
Other values (19)	550	5.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	295	3.0%
1	1309	13.5%
2	1708	17.6%
3	1608	16.6%
4	1361	14.1%
5	1010	10.4%
6	743	7.7%
7	506	5.2%
8	350	3.6%
9	242	2.5%

Value	Count	Frequency (%)
32	1	< 0.1%
29	1	< 0.1%
27	1	< 0.1%
26	1	< 0.1%
25	1	< 0.1%
24	3	< 0.1%
23	1	< 0.1%
21	5	0.1%
20	4	< 0.1%
19	4	< 0.1%

PercentTradesWBalance
Real number (ℝ)

HIGH CORRELATION

Distinct	93
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	65.92326

Minimum	0
Maximum	100
Zeros	43
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	75.8 KiB

Quantile statistics

Minimum	0
5-th percentile	29
Q1	50
median	67
Q3	83
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	33

Descriptive statistics

Standard deviation	21.781379
Coefficient of variation (CV)	0.33040506
Kurtosis	-0.50328088
Mean	65.92326
Median Absolute Deviation (MAD)	17
Skewness	-0.26415516
Sum	638269
Variance	474.42847
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	1120	11.6%
50	731	7.6%
67	608	6.3%
75	533	5.5%
80	372	3.8%
60	342	3.5%
83	316	3.3%
71	281	2.9%
33	272	2.8%
57	245	2.5%
Other values (83)	4862	50.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	43	0.4%
4	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	3	< 0.1%
9	2	< 0.1%
10	6	0.1%
11	8	0.1%
12	3	< 0.1%
13	15	0.2%

Value	Count	Frequency (%)
100	1120	11.6%
96	3	< 0.1%
95	13	0.1%
94	28	0.3%
93	37	0.4%
92	82	0.8%
91	82	0.8%
90	93	1.0%
89	138	1.4%
88	176	1.8%

Auto

Heatmap
Table

	AverageMInFile	ExternalRiskEstimate	MSinceMostRecentTradeOpen	MaxDelq/PublicRecLast12M	MaxDelqEver	NetFractionRevolvingBurden	NumInqLast6M	NumInqLast6Mexcl7days	NumRevolvingTradesWBalance	NumSatisfactoryTrades	NumTotalTrades	NumTrades60Ever/DerogPubRec	NumTrades90Ever/DerogPubRec	NumTradesOpeninLast12M	PercentInstallTrades	PercentTradesNeverDelq	PercentTradesWBalance	RiskPerformance
AverageMInFile	1.000	0.328	0.303	-0.025	-0.043	-0.209	-0.202	-0.199	-0.001	0.158	0.128	0.013	-0.012	-0.385	-0.158	-0.041	-0.199	0.249
ExternalRiskEstimate	0.328	1.000	0.143	0.622	0.533	-0.640	-0.231	-0.233	-0.361	0.004	-0.041	-0.479	-0.411	-0.195	-0.150	0.588	-0.454	0.461
MSinceMostRecentTradeOpen	0.303	0.143	1.000	-0.008	-0.001	-0.052	-0.336	-0.342	-0.209	-0.216	-0.215	0.017	0.005	-0.750	-0.023	-0.050	-0.002	0.069
MaxDelq/PublicRecLast12M	-0.025	0.622	-0.008	1.000	0.824	-0.184	-0.048	-0.052	-0.117	-0.032	-0.076	-0.539	-0.424	0.006	-0.122	0.833	-0.148	0.278
MaxDelqEver	-0.043	0.533	-0.001	0.824	1.000	-0.155	-0.042	-0.043	-0.057	0.012	-0.052	-0.687	-0.520	0.013	-0.124	0.902	-0.127	0.240
NetFractionRevolvingBurden	-0.209	-0.640	-0.052	-0.184	-0.155	1.000	0.097	0.098	0.411	-0.036	-0.018	0.122	0.094	0.078	0.132	-0.194	0.613	0.349
NumInqLast6M	-0.202	-0.231	-0.336	-0.048	-0.042	0.097	1.000	0.983	0.106	0.113	0.118	0.049	0.057	0.304	0.044	-0.022	0.050	0.081
NumInqLast6Mexcl7days	-0.199	-0.233	-0.342	-0.052	-0.043	0.098	0.983	1.000	0.110	0.117	0.123	0.049	0.058	0.306	0.044	-0.022	0.051	0.077
NumRevolvingTradesWBalance	-0.001	-0.361	-0.209	-0.117	-0.057	0.411	0.106	0.110	1.000	0.476	0.407	-0.028	-0.045	0.268	-0.244	-0.022	0.293	0.134
NumSatisfactoryTrades	0.158	0.004	-0.216	-0.032	0.012	-0.036	0.113	0.117	0.476	1.000	0.856	-0.133	-0.129	0.290	-0.080	0.127	-0.222	0.140
NumTotalTrades	0.128	-0.041	-0.215	-0.076	-0.052	-0.018	0.118	0.123	0.407	0.856	1.000	-0.044	-0.055	0.267	-0.031	0.049	-0.172	0.093
NumTrades60Ever/DerogPubRec	0.013	-0.479	0.017	-0.539	-0.687	0.122	0.049	0.049	-0.028	-0.133	-0.044	1.000	0.830	-0.033	0.120	-0.573	0.137	0.153
NumTrades90Ever/DerogPubRec	-0.012	-0.411	0.005	-0.424	-0.520	0.094	0.057	0.058	-0.045	-0.129	-0.055	0.830	1.000	-0.022	0.103	-0.407	0.118	0.120
NumTradesOpeninLast12M	-0.385	-0.195	-0.750	0.006	0.013	0.078	0.304	0.306	0.268	0.290	0.267	-0.033	-0.022	1.000	0.026	0.072	0.014	0.082
PercentInstallTrades	-0.158	-0.150	-0.023	-0.122	-0.124	0.132	0.044	0.044	-0.244	-0.080	-0.031	0.120	0.103	0.026	1.000	-0.133	0.386	0.137
PercentTradesNeverDelq	-0.041	0.588	-0.050	0.833	0.902	-0.194	-0.022	-0.022	-0.022	0.127	0.049	-0.573	-0.407	0.072	-0.133	1.000	-0.174	0.257
PercentTradesWBalance	-0.199	-0.454	-0.002	-0.148	-0.127	0.613	0.050	0.051	0.293	-0.222	-0.172	0.137	0.118	0.014	0.386	-0.174	1.000	0.274
RiskPerformance	0.249	0.461	0.069	0.278	0.240	0.349	0.081	0.077	0.134	0.140	0.093	0.153	0.120	0.082	0.137	0.257	0.274	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	RiskPerformance	ExternalRiskEstimate	MSinceMostRecentTradeOpen	AverageMInFile	NumSatisfactoryTrades	NumTrades60Ever/DerogPubRec	NumTrades90Ever/DerogPubRec	PercentTradesNeverDelq	MaxDelq/PublicRecLast12M	MaxDelqEver	NumTotalTrades	NumTradesOpeninLast12M	PercentInstallTrades	NumInqLast6M	NumInqLast6Mexcl7days	NetFractionRevolvingBurden	NumRevolvingTradesWBalance	PercentTradesWBalance
0	Bad	55.0	4.0	84.0	20.0	3.0	0.0	83.0	3.0	5.0	23.0	1.0	43.0	0.0	0.0	33.0	8.0	69.0
1	Bad	61.0	15.0	41.0	2.0	4.0	4.0	100.0	0.0	8.0	7.0	0.0	67.0	0.0	0.0	0.0	0.0	0.0
2	Bad	67.0	5.0	24.0	9.0	0.0	0.0	100.0	7.0	8.0	9.0	4.0	44.0	4.0	4.0	53.0	4.0	86.0
3	Bad	66.0	1.0	73.0	28.0	1.0	1.0	93.0	6.0	6.0	30.0	3.0	57.0	5.0	4.0	72.0	6.0	91.0
4	Bad	81.0	27.0	132.0	12.0	0.0	0.0	100.0	7.0	8.0	12.0	0.0	25.0	1.0	1.0	51.0	3.0	80.0
5	Bad	59.0	11.0	78.0	31.0	0.0	0.0	91.0	4.0	6.0	32.0	1.0	47.0	0.0	0.0	62.0	12.0	94.0
6	Good	54.0	7.0	37.0	25.0	0.0	0.0	92.0	4.0	6.0	26.0	3.0	58.0	4.0	4.0	89.0	7.0	100.0
7	Good	68.0	7.0	65.0	17.0	0.0	0.0	83.0	6.0	6.0	18.0	1.0	44.0	0.0	0.0	28.0	2.0	40.0
8	Bad	59.0	2.0	138.0	24.0	0.0	0.0	85.0	4.0	6.0	27.0	1.0	26.0	1.0	1.0	68.0	7.0	90.0
9	Bad	61.0	4.0	36.0	19.0	0.0	0.0	95.0	4.0	6.0	19.0	3.0	26.0	6.0	6.0	31.0	5.0	62.0

	RiskPerformance	ExternalRiskEstimate	MSinceMostRecentTradeOpen	AverageMInFile	NumSatisfactoryTrades	NumTrades60Ever/DerogPubRec	NumTrades90Ever/DerogPubRec	PercentTradesNeverDelq	MaxDelq/PublicRecLast12M	MaxDelqEver	NumTotalTrades	NumTradesOpeninLast12M	PercentInstallTrades	NumInqLast6M	NumInqLast6Mexcl7days	NetFractionRevolvingBurden	NumRevolvingTradesWBalance	PercentTradesWBalance
9672	Good	57.0	4.0	87.0	18.0	0.0	0.0	89.0	4.0	6.0	18.0	1.0	56.0	1.0	1.0	93.0	5.0	100.0
9673	Good	84.0	6.0	103.0	25.0	0.0	0.0	100.0	7.0	8.0	25.0	2.0	24.0	0.0	0.0	10.0	4.0	70.0
9674	Good	79.0	2.0	68.0	27.0	0.0	0.0	100.0	7.0	8.0	30.0	3.0	36.0	4.0	4.0	1.0	4.0	60.0
9675	Good	90.0	5.0	92.0	13.0	0.0	0.0	100.0	7.0	8.0	13.0	1.0	46.0	2.0	2.0	5.0	3.0	100.0
9676	Bad	75.0	2.0	121.0	37.0	1.0	1.0	83.0	4.0	3.0	43.0	1.0	7.0	1.0	1.0	34.0	7.0	53.0
9677	Good	73.0	5.0	57.0	21.0	0.0	0.0	95.0	6.0	6.0	21.0	5.0	19.0	0.0	0.0	26.0	5.0	100.0
9678	Bad	65.0	39.0	68.0	11.0	0.0	0.0	92.0	6.0	6.0	12.0	0.0	42.0	1.0	1.0	86.0	2.0	80.0
9679	Bad	74.0	6.0	64.0	18.0	1.0	1.0	100.0	6.0	8.0	18.0	1.0	33.0	4.0	4.0	6.0	5.0	56.0
9680	Bad	72.0	12.0	113.0	42.0	2.0	2.0	96.0	6.0	2.0	45.0	0.0	20.0	0.0	0.0	19.0	4.0	38.0
9681	Bad	66.0	1.0	17.0	4.0	0.0	0.0	100.0	7.0	8.0	5.0	2.0	60.0	3.0	2.0	67.0	2.0	100.0

Most frequently occurring

	RiskPerformance	ExternalRiskEstimate	MSinceMostRecentTradeOpen	AverageMInFile	NumSatisfactoryTrades	NumTrades60Ever/DerogPubRec	NumTrades90Ever/DerogPubRec	PercentTradesNeverDelq	MaxDelq/PublicRecLast12M	MaxDelqEver	NumTotalTrades	NumTradesOpeninLast12M	PercentInstallTrades	NumInqLast6M	NumInqLast6Mexcl7days	NetFractionRevolvingBurden	NumRevolvingTradesWBalance	PercentTradesWBalance	# duplicates
0	Bad	62.0	9.0	42.0	10.0	2.0	1.0	83.0	3.0	5.0	12.0	2.0	33.0	1.0	1.0	14.0	4.0	63.0	2
1	Bad	64.0	18.0	124.0	16.0	2.0	0.0	47.0	4.0	5.0	19.0	0.0	74.0	4.0	4.0	27.0	2.0	100.0	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring